package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_CompoundUniqueGroup({
        @_DDL_CompoundUnique(name = "rvmer_ord_id", columns = {"mer_ord_id", "mer_id"})
})
@_DDL_Table(name = "qb_reversal", simpleName = "", engine = MysqlDriver.InnoDB, comment = "内部户冲正")
public class _DDL_QbReversal {

    @_DDL_Primary()
    @_DDL_Column(name = "rv_id", type = SqlType.INT, nullable = false, autoIncrement = true, comment = "冲正ID")
    private Integer id;

    @_DDL_Column(name = "rv_amt", type = SqlType.INT, nullable = false, comment = "金额，分")
    private Integer amt;

    @_DDL_Column(name = "rv_state", type = SqlType.INT, nullable = false, comment = "状态，0：未完、1：已完成")
    private Integer state;

    @_DDL_Column(name = "trans_id", type = SqlType.CHAR, size = 16, nullable = false, comment = "交易流水号")
    private String transId;

    @_DDL_Column(name = "qb_id", type = SqlType.CHAR, size = 20, nullable = false, comment = "钱包ID")
    private String qbId;

    @_DDL_Column(name = "mer_id", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "商户号")
    private String merId;

    @_DDL_Column(name = "mer_ord_id", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "商户订单号")
    private String merOrdId;

    @_DDL_Column(name = "rv_date", type = SqlType.DATETIME, comment = "成功时间")
    private java.time.LocalDateTime date;

    @_DDL_Column(name = "cr_date", type = SqlType.DATETIME, comment = "创建时间")
    private java.time.LocalDateTime crDate;

    @_DDL_Column(name = "rv_remark", type = SqlType.VARCHAR, size = 100, comment = "备注")
    private String remark;

}
